package kr.or.kead.daegu.global;

public class Config {
	
	public final static String[][] INPUT_FIELD_NAME={
		{"사원코드","사원명"},
		{"제품코드","제품명","판매정가", "판매원가"},
		{"거래처코드","거래처명"}
	};
	
	public final static String[] INPUT_COMBO_NAME={
		"사원등급", "거래처등급"
	};
	
	public final static String[][] INPUT_COMBO_LIST={
		{"A","B","C"},{"L","M","S"}
	};
	
	public final static String[][] LBL_LIST_COLNAME={ 
		{"사원코드","사원명","사원등급"},
		{"제품코드","제품명","판매정가", "판매원가"},
		{"거래처코드","거래처명","거래처등급"}
	};

	public final static Class[][] LBL_LIST_COLCLASS = {
		{String.class, String.class, String.class},
		{String.class, String.class, Integer.class,Integer.class},
		{String.class, String.class, String.class}
	};
	

	public final static String[] SQL_SELECT={
		"select code,name,grade from emp order by code",
		"select pcode, pname, regprice, primeprice from product order by pcode",
		"select bcode, bname, bgrade from business order by bcode;"
	};
	
	public final static String[] SQL_INSERT={
		"insert into emp values(?,?,?)",
		"insert into product values(?,?,?,?)",
		"insert into business values(?,?,?)",
		"insert into salehistory values(?, ?,?, ?, ?, ?)"
	};
	
	public final static String[] SQL_UPDATE={
		"update emp set name=?, grade=? where code=?",
		"update product set pname=?, regprice=?, primeprice=? where pcode=?",
		"update business set bname=?, bgrade=? where bcode=?"
	};
	
	public final static String[] SQL_DELETE={
		"delete from emp where code = ?",
		"delete from product where pcode = ?",
		"delete from business where bcode=?"

	};
	
	public final static String[] SQL_DELETE_SEARCH={
		"select code, name, grade from emp where code = ?",
		"select pcode, pname, regprice, primeprice from product where pcode=?",
		"select bcode, bname, bgrade from business where bcode=?"
	};
	
}
